<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>1101: DBUtility.DbHelperSQL类参考</title>
<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javaScript" src="search/search.js"></script>
<link href="doxygen.css" rel="stylesheet" type="text/css"/>
</head>
<body onload='searchBox.OnSelectItem(0);'>
<!-- 制作者 Doxygen 1.7.2 -->
<script type="text/javascript"><!--
var searchBox = new SearchBox("searchBox", "search",false,'搜索');
--></script>
<div class="navigation" id="top">
  <div class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>首页</span></a></li>
      <li><a href="namespaces.html"><span>包</span></a></li>
      <li class="current"><a href="annotated.html"><span>类</span></a></li>
      <li id="searchli">
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="搜索" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div class="tabs2">
    <ul class="tablist">
      <li><a href="annotated.html"><span>组合类型列表</span></a></li>
      <li><a href="classes.html"><span>组合类型索引</span></a></li>
      <li><a href="hierarchy.html"><span>类继承关系</span></a></li>
      <li><a href="functions.html"><span>组合类型成员</span></a></li>
    </ul>
  </div>
  <div class="navpath">
    <ul>
      <li><a class="el" href="namespace_d_b_utility.html">DBUtility</a>      </li>
      <li><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html">DbHelperSQL</a>      </li>
    </ul>
  </div>
</div>
<div class="header">
  <div class="summary">
<a href="#pub-static-methods">静态公有成员</a> &#124;
<a href="#pub-static-attribs">静态公有属性</a>  </div>
  <div class="headertitle">
<h1>DBUtility.DbHelperSQL类参考</h1>  </div>
</div>
<div class="contents">
<!-- doxytag: class="DBUtility::DbHelperSQL" -->
<p>数据访问抽象基础类  
<a href="#_details">更多...</a></p>

<p><a href="class_d_b_utility_1_1_db_helper_s_q_l-members.html">所有成员的列表。</a></p>
<table class="memberdecls">
<tr><td colspan="2"><h2><a name="pub-static-methods"></a>
静态公有成员</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#ac2f6d3a7fae8fab77ee7a37e2f0cad09">ColumnExists</a> (string tableName, string columnName)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">判断是否存在某表的某个字段  <a href="#ac2f6d3a7fae8fab77ee7a37e2f0cad09"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="aeda9bfff3209278d1754517e507cbee8"></a><!-- doxytag: member="DBUtility::DbHelperSQL::GetMaxID" ref="aeda9bfff3209278d1754517e507cbee8" args="(string FieldName, string TableName)" -->
static int&#160;</td><td class="memItemRight" valign="bottom"><b>GetMaxID</b> (string FieldName, string TableName)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="aeb46e514b2fdf0f4e43a70240638b148"></a><!-- doxytag: member="DBUtility::DbHelperSQL::Exists" ref="aeb46e514b2fdf0f4e43a70240638b148" args="(string strSql)" -->
static bool&#160;</td><td class="memItemRight" valign="bottom"><b>Exists</b> (string strSql)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a205c18cb5748bcdea2bc399b6acfe2c8">TabExists</a> (string TableName)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">表是否存在  <a href="#a205c18cb5748bcdea2bc399b6acfe2c8"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ae0ab73e74afcd17493a1cc679ea690d1"></a><!-- doxytag: member="DBUtility::DbHelperSQL::Exists" ref="ae0ab73e74afcd17493a1cc679ea690d1" args="(string strSql, params SqlParameter[] cmdParms)" -->
static bool&#160;</td><td class="memItemRight" valign="bottom"><b>Exists</b> (string strSql, params SqlParameter[] cmdParms)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a982a3e7cba7592837b22d4a7446b5d15">ExecuteSql</a> (string SQLString)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行SQL语句，返回影响的记录数  <a href="#a982a3e7cba7592837b22d4a7446b5d15"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="aa5b997789086410fa2d0f575d3e3a16e"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteSqlByTime" ref="aa5b997789086410fa2d0f575d3e3a16e" args="(string SQLString, int Times)" -->
static int&#160;</td><td class="memItemRight" valign="bottom"><b>ExecuteSqlByTime</b> (string SQLString, int Times)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a028853cc819f2765653abcc3400d8e99">ExecuteSqlTran</a> (List&lt; String &gt; SQLStringList)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行多条SQL语句，实现数据库事务。  <a href="#a028853cc819f2765653abcc3400d8e99"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a8e428fd06de1a706c884ea557639c869">ExecuteSql</a> (string SQLString, string content)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行带一个存储过程参数的的SQL语句。  <a href="#a8e428fd06de1a706c884ea557639c869"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static object&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#ac12baa785c55b85dd37e90a51148cf8d">ExecuteSqlGet</a> (string SQLString, string content)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行带一个存储过程参数的的SQL语句。  <a href="#ac12baa785c55b85dd37e90a51148cf8d"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a1073cd4f929a379fc7d3c0422bd05a0f">ExecuteSqlInsertImg</a> (string strSQL, byte[] fs)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">向数据库里插入图像格式的字段(和上面情况类似的另一种实例)  <a href="#a1073cd4f929a379fc7d3c0422bd05a0f"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static object&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a637b01d526fa0a85208b901b3af91205">GetSingle</a> (string SQLString)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行一条计算查询结果语句，返回查询结果（object）。  <a href="#a637b01d526fa0a85208b901b3af91205"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="add9588f8bb4b9e269f46cada65005583"></a><!-- doxytag: member="DBUtility::DbHelperSQL::GetSingle" ref="add9588f8bb4b9e269f46cada65005583" args="(string SQLString, int Times)" -->
static object&#160;</td><td class="memItemRight" valign="bottom"><b>GetSingle</b> (string SQLString, int Times)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static SqlDataReader&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#afc8ac00e8af41e4144c51d150b33afc3">ExecuteReader</a> (string strSQL)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行查询语句，返回SqlDataReader ( 注意：调用该方法后，一定要对SqlDataReader进行Close )  <a href="#afc8ac00e8af41e4144c51d150b33afc3"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static DataSet&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a6779ec56f3bcb3cbbeaf871db83a497c">Query</a> (string SQLString)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行查询语句，返回DataSet  <a href="#a6779ec56f3bcb3cbbeaf871db83a497c"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ab70d956f5d5101bcf4ba12ce3d005d44"></a><!-- doxytag: member="DBUtility::DbHelperSQL::Query" ref="ab70d956f5d5101bcf4ba12ce3d005d44" args="(string SQLString, int Times)" -->
static DataSet&#160;</td><td class="memItemRight" valign="bottom"><b>Query</b> (string SQLString, int Times)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a03d88b3e6c0333483834898d92623548">ExecuteSql</a> (string SQLString, params SqlParameter[] cmdParms)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行SQL语句，返回影响的记录数  <a href="#a03d88b3e6c0333483834898d92623548"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a88e179c39bf3cee48595d23ffaac3bc1">ExecuteSqlTran</a> (Hashtable SQLStringList)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行多条SQL语句，实现数据库事务。  <a href="#a88e179c39bf3cee48595d23ffaac3bc1"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a18a7609eb9a18f225af66e95ef5feabc">ExecuteSqlTran</a> (System.Collections.Generic.List&lt; <a class="el" href="class_d_b_utility_1_1_command_info.html">CommandInfo</a> &gt; cmdList)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行多条SQL语句，实现数据库事务。  <a href="#a18a7609eb9a18f225af66e95ef5feabc"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a344aa5e98e849f1b5ee5c50214e9f20d">ExecuteSqlTranWithIndentity</a> (System.Collections.Generic.List&lt; <a class="el" href="class_d_b_utility_1_1_command_info.html">CommandInfo</a> &gt; SQLStringList)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行多条SQL语句，实现数据库事务。  <a href="#a344aa5e98e849f1b5ee5c50214e9f20d"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static void&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a90e5be322268680dffd8900d2917f180">ExecuteSqlTranWithIndentity</a> (Hashtable SQLStringList)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行多条SQL语句，实现数据库事务。  <a href="#a90e5be322268680dffd8900d2917f180"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static object&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#ad80cf8b5b1447c7a5721ee41b05f8b60">GetSingle</a> (string SQLString, params SqlParameter[] cmdParms)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行一条计算查询结果语句，返回查询结果（object）。  <a href="#ad80cf8b5b1447c7a5721ee41b05f8b60"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static SqlDataReader&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a4b1962364133097a3558e65952a737bf">ExecuteReader</a> (string SQLString, params SqlParameter[] cmdParms)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行查询语句，返回SqlDataReader ( 注意：调用该方法后，一定要对SqlDataReader进行Close )  <a href="#a4b1962364133097a3558e65952a737bf"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static DataSet&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a072e5290ef90784308edca673cfff577">Query</a> (string SQLString, params SqlParameter[] cmdParms)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行查询语句，返回DataSet  <a href="#a072e5290ef90784308edca673cfff577"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static SqlDataReader&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#ab03de63b1aef3355b2a22e8d3ab00d39">RunProcedure</a> (string storedProcName, IDataParameter[] parameters)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行存储过程，返回SqlDataReader ( 注意：调用该方法后，一定要对SqlDataReader进行Close )  <a href="#ab03de63b1aef3355b2a22e8d3ab00d39"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static DataSet&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a93b74ee65bd8f3d98f61b7eadb366abf">RunProcedure</a> (string storedProcName, IDataParameter[] parameters, string tableName)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行存储过程  <a href="#a93b74ee65bd8f3d98f61b7eadb366abf"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a3e91c887955434baca760c6b42f9a1c5"></a><!-- doxytag: member="DBUtility::DbHelperSQL::RunProcedure" ref="a3e91c887955434baca760c6b42f9a1c5" args="(string storedProcName, IDataParameter[] parameters, string tableName, int Times)" -->
static DataSet&#160;</td><td class="memItemRight" valign="bottom"><b>RunProcedure</b> (string storedProcName, IDataParameter[] parameters, string tableName, int Times)</td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static int&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a8c3743a7db235ae95e38c5ab073ae64b">RunProcedure</a> (string storedProcName, IDataParameter[] parameters, out int rowsAffected)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">执行存储过程，返回影响的行数  <a href="#a8c3743a7db235ae95e38c5ab073ae64b"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static DataTable&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#aaf0d2a57531d9f853319b21b3dca85d0">FindByConditions</a> (object obj, string conditions)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">根据条件返回查询到的DataTable  <a href="#aaf0d2a57531d9f853319b21b3dca85d0"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static DataTable&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a16212686ded6e6cce6b4c220caed9037">FindByPage</a> (object obj, string start, string limit, string conditions)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">分页查询，返回当前页的DataTable  <a href="#a16212686ded6e6cce6b4c220caed9037"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static string&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a1aada4d7d68dc9775226ba9a6c999187">GetCountByConditions</a> (object obj, string conditions)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">返回符合记录的数据条数  <a href="#a1aada4d7d68dc9775226ba9a6c999187"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#ade05cbbab48b7d54043d69b24fa37a09">Delete</a> (object obj)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">根据表名删除记录  <a href="#ade05cbbab48b7d54043d69b24fa37a09"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a3abbf2203444a26efaeb9adde81053f0">Delete</a> (object obj, string conditions)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">批量删除  <a href="#a3abbf2203444a26efaeb9adde81053f0"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a42745bc7ee24e4860bc6ff6e97a7bb41">Insert</a> (object obj)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">添加一条记录  <a href="#a42745bc7ee24e4860bc6ff6e97a7bb41"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top">static bool&#160;</td><td class="memItemRight" valign="bottom"><a class="el" href="class_d_b_utility_1_1_db_helper_s_q_l.html#a18f6b210145985e7a52101b7f814cabc">Update</a> (object obj)</td></tr>
<tr><td class="mdescLeft">&#160;</td><td class="mdescRight">更新记录  <a href="#a18f6b210145985e7a52101b7f814cabc"></a><br/></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a90418d4f5ef4c18cabba70d259bd021b"></a><!-- doxytag: member="DBUtility::DbHelperSQL::Update" ref="a90418d4f5ef4c18cabba70d259bd021b" args="(object obj, string sets, string conditions)" -->
static bool&#160;</td><td class="memItemRight" valign="bottom"><b>Update</b> (object obj, string sets, string conditions)</td></tr>
<tr><td colspan="2"><h2><a name="pub-static-attribs"></a>
静态公有属性</h2></td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ae4c47207754949e6e7d65733142a787f"></a><!-- doxytag: member="DBUtility::DbHelperSQL::connectionString" ref="ae4c47207754949e6e7d65733142a787f" args="" -->
static string&#160;</td><td class="memItemRight" valign="bottom"><b>connectionString</b> = PubConstant.ConnectionString</td></tr>
<tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a58aed0324cb41769f893be6b62bc5722"></a><!-- doxytag: member="DBUtility::DbHelperSQL::log" ref="a58aed0324cb41769f893be6b62bc5722" args="" -->
static readonly log4net.ILog&#160;</td><td class="memItemRight" valign="bottom"><b>log</b> = log4net.LogManager.GetLogger(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType)</td></tr>
</table>
<hr/><a name="_details"></a><h2>详细描述</h2>
<p>数据访问抽象基础类 </p>
<hr/><h2>成员函数文档</h2>
<a class="anchor" id="ac2f6d3a7fae8fab77ee7a37e2f0cad09"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ColumnExists" ref="ac2f6d3a7fae8fab77ee7a37e2f0cad09" args="(string tableName, string columnName)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static bool DBUtility.DbHelperSQL.ColumnExists </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>tableName</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>columnName</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>判断是否存在某表的某个字段 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">tableName</td><td>表名称</td></tr>
    <tr><td class="paramname">columnName</td><td>列名称</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>是否存在</dd></dl>

</div>
</div>
<a class="anchor" id="ade05cbbab48b7d54043d69b24fa37a09"></a><!-- doxytag: member="DBUtility::DbHelperSQL::Delete" ref="ade05cbbab48b7d54043d69b24fa37a09" args="(object obj)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static bool DBUtility.DbHelperSQL.Delete </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"> <em>obj</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>根据表名删除记录 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">TableName</td><td>表名</td></tr>
    <tr><td class="paramname">AutoID</td><td>自动增长id</td></tr>
    <tr><td class="paramname">value</td><td>id值</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>是否删除</dd></dl>

</div>
</div>
<a class="anchor" id="a3abbf2203444a26efaeb9adde81053f0"></a><!-- doxytag: member="DBUtility::DbHelperSQL::Delete" ref="a3abbf2203444a26efaeb9adde81053f0" args="(object obj, string conditions)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static bool DBUtility.DbHelperSQL.Delete </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"> <em>obj</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>conditions</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>批量删除 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">obj</td><td>对象名</td></tr>
    <tr><td class="paramname">condition</td><td>条件</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>返回是否成功</dd></dl>

</div>
</div>
<a class="anchor" id="a4b1962364133097a3558e65952a737bf"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteReader" ref="a4b1962364133097a3558e65952a737bf" args="(string SQLString, params SqlParameter[] cmdParms)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static SqlDataReader DBUtility.DbHelperSQL.ExecuteReader </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>SQLString</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">params SqlParameter[]&#160;</td>
          <td class="paramname"> <em>cmdParms</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行查询语句，返回SqlDataReader ( 注意：调用该方法后，一定要对SqlDataReader进行Close ) </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">strSQL</td><td>查询语句</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>SqlDataReader</dd></dl>

</div>
</div>
<a class="anchor" id="afc8ac00e8af41e4144c51d150b33afc3"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteReader" ref="afc8ac00e8af41e4144c51d150b33afc3" args="(string strSQL)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static SqlDataReader DBUtility.DbHelperSQL.ExecuteReader </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>strSQL</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行查询语句，返回SqlDataReader ( 注意：调用该方法后，一定要对SqlDataReader进行Close ) </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">strSQL</td><td>查询语句</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>SqlDataReader</dd></dl>

</div>
</div>
<a class="anchor" id="a03d88b3e6c0333483834898d92623548"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteSql" ref="a03d88b3e6c0333483834898d92623548" args="(string SQLString, params SqlParameter[] cmdParms)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static int DBUtility.DbHelperSQL.ExecuteSql </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>SQLString</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">params SqlParameter[]&#160;</td>
          <td class="paramname"> <em>cmdParms</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行SQL语句，返回影响的记录数 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLString</td><td>SQL语句</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>影响的记录数</dd></dl>

</div>
</div>
<a class="anchor" id="a8e428fd06de1a706c884ea557639c869"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteSql" ref="a8e428fd06de1a706c884ea557639c869" args="(string SQLString, string content)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static int DBUtility.DbHelperSQL.ExecuteSql </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>SQLString</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>content</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行带一个存储过程参数的的SQL语句。 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLString</td><td>SQL语句</td></tr>
    <tr><td class="paramname">content</td><td>参数内容,比如一个字段是格式复杂的文章，有特殊符号，可以通过这个方式添加</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>影响的记录数</dd></dl>

</div>
</div>
<a class="anchor" id="a982a3e7cba7592837b22d4a7446b5d15"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteSql" ref="a982a3e7cba7592837b22d4a7446b5d15" args="(string SQLString)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static int DBUtility.DbHelperSQL.ExecuteSql </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>SQLString</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行SQL语句，返回影响的记录数 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLString</td><td>SQL语句</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>影响的记录数</dd></dl>

</div>
</div>
<a class="anchor" id="ac12baa785c55b85dd37e90a51148cf8d"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteSqlGet" ref="ac12baa785c55b85dd37e90a51148cf8d" args="(string SQLString, string content)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static object DBUtility.DbHelperSQL.ExecuteSqlGet </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>SQLString</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>content</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行带一个存储过程参数的的SQL语句。 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLString</td><td>SQL语句</td></tr>
    <tr><td class="paramname">content</td><td>参数内容,比如一个字段是格式复杂的文章，有特殊符号，可以通过这个方式添加</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>影响的记录数</dd></dl>

</div>
</div>
<a class="anchor" id="a1073cd4f929a379fc7d3c0422bd05a0f"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteSqlInsertImg" ref="a1073cd4f929a379fc7d3c0422bd05a0f" args="(string strSQL, byte[] fs)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static int DBUtility.DbHelperSQL.ExecuteSqlInsertImg </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>strSQL</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">byte[]&#160;</td>
          <td class="paramname"> <em>fs</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>向数据库里插入图像格式的字段(和上面情况类似的另一种实例) </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">strSQL</td><td>SQL语句</td></tr>
    <tr><td class="paramname">fs</td><td>图像字节,数据库的字段类型为image的情况</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>影响的记录数</dd></dl>

</div>
</div>
<a class="anchor" id="a028853cc819f2765653abcc3400d8e99"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteSqlTran" ref="a028853cc819f2765653abcc3400d8e99" args="(List&lt; String &gt; SQLStringList)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static int DBUtility.DbHelperSQL.ExecuteSqlTran </td>
          <td>(</td>
          <td class="paramtype">List&lt; String &gt;&#160;</td>
          <td class="paramname"> <em>SQLStringList</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行多条SQL语句，实现数据库事务。 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLStringList</td><td>多条SQL语句</td></tr>
  </table>
  </dd>
</dl>

</div>
</div>
<a class="anchor" id="a88e179c39bf3cee48595d23ffaac3bc1"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteSqlTran" ref="a88e179c39bf3cee48595d23ffaac3bc1" args="(Hashtable SQLStringList)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static void DBUtility.DbHelperSQL.ExecuteSqlTran </td>
          <td>(</td>
          <td class="paramtype">Hashtable&#160;</td>
          <td class="paramname"> <em>SQLStringList</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行多条SQL语句，实现数据库事务。 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLStringList</td><td>SQL语句的哈希表（key为sql语句，value是该语句的SqlParameter[]）</td></tr>
  </table>
  </dd>
</dl>

</div>
</div>
<a class="anchor" id="a18a7609eb9a18f225af66e95ef5feabc"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteSqlTran" ref="a18a7609eb9a18f225af66e95ef5feabc" args="(System.Collections.Generic.List&lt; CommandInfo &gt; cmdList)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static int DBUtility.DbHelperSQL.ExecuteSqlTran </td>
          <td>(</td>
          <td class="paramtype">System.Collections.Generic.List&lt; <a class="el" href="class_d_b_utility_1_1_command_info.html">CommandInfo</a> &gt;&#160;</td>
          <td class="paramname"> <em>cmdList</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行多条SQL语句，实现数据库事务。 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLStringList</td><td>SQL语句的哈希表（key为sql语句，value是该语句的SqlParameter[]）</td></tr>
  </table>
  </dd>
</dl>

</div>
</div>
<a class="anchor" id="a344aa5e98e849f1b5ee5c50214e9f20d"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteSqlTranWithIndentity" ref="a344aa5e98e849f1b5ee5c50214e9f20d" args="(System.Collections.Generic.List&lt; CommandInfo &gt; SQLStringList)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static void DBUtility.DbHelperSQL.ExecuteSqlTranWithIndentity </td>
          <td>(</td>
          <td class="paramtype">System.Collections.Generic.List&lt; <a class="el" href="class_d_b_utility_1_1_command_info.html">CommandInfo</a> &gt;&#160;</td>
          <td class="paramname"> <em>SQLStringList</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行多条SQL语句，实现数据库事务。 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLStringList</td><td>SQL语句的哈希表（key为sql语句，value是该语句的SqlParameter[]）</td></tr>
  </table>
  </dd>
</dl>

</div>
</div>
<a class="anchor" id="a90e5be322268680dffd8900d2917f180"></a><!-- doxytag: member="DBUtility::DbHelperSQL::ExecuteSqlTranWithIndentity" ref="a90e5be322268680dffd8900d2917f180" args="(Hashtable SQLStringList)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static void DBUtility.DbHelperSQL.ExecuteSqlTranWithIndentity </td>
          <td>(</td>
          <td class="paramtype">Hashtable&#160;</td>
          <td class="paramname"> <em>SQLStringList</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行多条SQL语句，实现数据库事务。 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLStringList</td><td>SQL语句的哈希表（key为sql语句，value是该语句的SqlParameter[]）</td></tr>
  </table>
  </dd>
</dl>

</div>
</div>
<a class="anchor" id="aaf0d2a57531d9f853319b21b3dca85d0"></a><!-- doxytag: member="DBUtility::DbHelperSQL::FindByConditions" ref="aaf0d2a57531d9f853319b21b3dca85d0" args="(object obj, string conditions)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static DataTable DBUtility.DbHelperSQL.FindByConditions </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"> <em>obj</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>conditions</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>根据条件返回查询到的DataTable </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">TableName</td><td>表名</td></tr>
    <tr><td class="paramname">conditions</td><td>条件</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

</div>
</div>
<a class="anchor" id="a16212686ded6e6cce6b4c220caed9037"></a><!-- doxytag: member="DBUtility::DbHelperSQL::FindByPage" ref="a16212686ded6e6cce6b4c220caed9037" args="(object obj, string start, string limit, string conditions)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static DataTable DBUtility.DbHelperSQL.FindByPage </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"> <em>obj</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>start</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>limit</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>conditions</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>分页查询，返回当前页的DataTable </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">TableName</td><td>表名</td></tr>
    <tr><td class="paramname">AutoID</td><td>自动增长列</td></tr>
    <tr><td class="paramname">start</td><td>起始记录号</td></tr>
    <tr><td class="paramname">limit</td><td>分页大小</td></tr>
    <tr><td class="paramname">conditions</td><td>附加条件</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

</div>
</div>
<a class="anchor" id="a1aada4d7d68dc9775226ba9a6c999187"></a><!-- doxytag: member="DBUtility::DbHelperSQL::GetCountByConditions" ref="a1aada4d7d68dc9775226ba9a6c999187" args="(object obj, string conditions)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static string DBUtility.DbHelperSQL.GetCountByConditions </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"> <em>obj</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>conditions</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>返回符合记录的数据条数 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">TableName</td><td>表名</td></tr>
    <tr><td class="paramname">conditions</td><td>条件</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

</div>
</div>
<a class="anchor" id="ad80cf8b5b1447c7a5721ee41b05f8b60"></a><!-- doxytag: member="DBUtility::DbHelperSQL::GetSingle" ref="ad80cf8b5b1447c7a5721ee41b05f8b60" args="(string SQLString, params SqlParameter[] cmdParms)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static object DBUtility.DbHelperSQL.GetSingle </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>SQLString</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">params SqlParameter[]&#160;</td>
          <td class="paramname"> <em>cmdParms</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行一条计算查询结果语句，返回查询结果（object）。 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLString</td><td>计算查询结果语句</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>查询结果（object）</dd></dl>

</div>
</div>
<a class="anchor" id="a637b01d526fa0a85208b901b3af91205"></a><!-- doxytag: member="DBUtility::DbHelperSQL::GetSingle" ref="a637b01d526fa0a85208b901b3af91205" args="(string SQLString)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static object DBUtility.DbHelperSQL.GetSingle </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>SQLString</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行一条计算查询结果语句，返回查询结果（object）。 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLString</td><td>计算查询结果语句</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>查询结果（object）</dd></dl>

</div>
</div>
<a class="anchor" id="a42745bc7ee24e4860bc6ff6e97a7bb41"></a><!-- doxytag: member="DBUtility::DbHelperSQL::Insert" ref="a42745bc7ee24e4860bc6ff6e97a7bb41" args="(object obj)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static bool DBUtility.DbHelperSQL.Insert </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"> <em>obj</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>添加一条记录 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">obj</td><td>表名称对象</td></tr>
    <tr><td class="paramname">AutoID</td><td>自增列</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>是否插入成功</dd></dl>

</div>
</div>
<a class="anchor" id="a072e5290ef90784308edca673cfff577"></a><!-- doxytag: member="DBUtility::DbHelperSQL::Query" ref="a072e5290ef90784308edca673cfff577" args="(string SQLString, params SqlParameter[] cmdParms)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static DataSet DBUtility.DbHelperSQL.Query </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>SQLString</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">params SqlParameter[]&#160;</td>
          <td class="paramname"> <em>cmdParms</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行查询语句，返回DataSet </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLString</td><td>查询语句</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>DataSet</dd></dl>

</div>
</div>
<a class="anchor" id="a6779ec56f3bcb3cbbeaf871db83a497c"></a><!-- doxytag: member="DBUtility::DbHelperSQL::Query" ref="a6779ec56f3bcb3cbbeaf871db83a497c" args="(string SQLString)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static DataSet DBUtility.DbHelperSQL.Query </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>SQLString</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行查询语句，返回DataSet </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">SQLString</td><td>查询语句</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>DataSet</dd></dl>

</div>
</div>
<a class="anchor" id="ab03de63b1aef3355b2a22e8d3ab00d39"></a><!-- doxytag: member="DBUtility::DbHelperSQL::RunProcedure" ref="ab03de63b1aef3355b2a22e8d3ab00d39" args="(string storedProcName, IDataParameter[] parameters)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static SqlDataReader DBUtility.DbHelperSQL.RunProcedure </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>storedProcName</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">IDataParameter[]&#160;</td>
          <td class="paramname"> <em>parameters</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行存储过程，返回SqlDataReader ( 注意：调用该方法后，一定要对SqlDataReader进行Close ) </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">storedProcName</td><td>存储过程名</td></tr>
    <tr><td class="paramname">parameters</td><td>存储过程参数</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>SqlDataReader</dd></dl>

</div>
</div>
<a class="anchor" id="a8c3743a7db235ae95e38c5ab073ae64b"></a><!-- doxytag: member="DBUtility::DbHelperSQL::RunProcedure" ref="a8c3743a7db235ae95e38c5ab073ae64b" args="(string storedProcName, IDataParameter[] parameters, out int rowsAffected)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static int DBUtility.DbHelperSQL.RunProcedure </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>storedProcName</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">IDataParameter[]&#160;</td>
          <td class="paramname"> <em>parameters</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">out int&#160;</td>
          <td class="paramname"> <em>rowsAffected</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行存储过程，返回影响的行数 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">storedProcName</td><td>存储过程名</td></tr>
    <tr><td class="paramname">parameters</td><td>存储过程参数</td></tr>
    <tr><td class="paramname">rowsAffected</td><td>影响的行数</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

</div>
</div>
<a class="anchor" id="a93b74ee65bd8f3d98f61b7eadb366abf"></a><!-- doxytag: member="DBUtility::DbHelperSQL::RunProcedure" ref="a93b74ee65bd8f3d98f61b7eadb366abf" args="(string storedProcName, IDataParameter[] parameters, string tableName)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static DataSet DBUtility.DbHelperSQL.RunProcedure </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>storedProcName</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">IDataParameter[]&#160;</td>
          <td class="paramname"> <em>parameters</em>, </td>
        </tr>
        <tr>
          <td class="paramkey"></td>
          <td></td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>tableName</em>&#160;</td>
        </tr>
        <tr>
          <td></td>
          <td>)</td>
          <td></td><td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>执行存储过程 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">storedProcName</td><td>存储过程名</td></tr>
    <tr><td class="paramname">parameters</td><td>存储过程参数</td></tr>
    <tr><td class="paramname">tableName</td><td>DataSet结果中的表名</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>DataSet</dd></dl>

</div>
</div>
<a class="anchor" id="a205c18cb5748bcdea2bc399b6acfe2c8"></a><!-- doxytag: member="DBUtility::DbHelperSQL::TabExists" ref="a205c18cb5748bcdea2bc399b6acfe2c8" args="(string TableName)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static bool DBUtility.DbHelperSQL.TabExists </td>
          <td>(</td>
          <td class="paramtype">string&#160;</td>
          <td class="paramname"> <em>TableName</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>表是否存在 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">TableName</td><td></td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd></dd></dl>

</div>
</div>
<a class="anchor" id="a18f6b210145985e7a52101b7f814cabc"></a><!-- doxytag: member="DBUtility::DbHelperSQL::Update" ref="a18f6b210145985e7a52101b7f814cabc" args="(object obj)" -->
<div class="memitem">
<div class="memproto">
      <table class="memname">
        <tr>
          <td class="memname">static bool DBUtility.DbHelperSQL.Update </td>
          <td>(</td>
          <td class="paramtype">object&#160;</td>
          <td class="paramname"> <em>obj</em>&#160;)</td>
          <td><code> [static]</code></td>
        </tr>
      </table>
</div>
<div class="memdoc">

<p>更新记录 </p>
<dl><dt><b>参数:</b></dt><dd>
  <table class="params">
    <tr><td class="paramname">obj</td><td>表实体</td></tr>
    <tr><td class="paramname">AutoID</td><td>自动id</td></tr>
  </table>
  </dd>
</dl>
<dl class="return"><dt><b>返回:</b></dt><dd>是否更新成功</dd></dl>

</div>
</div>
<hr/>该类的文档由以下文件生成：<ul>
<li>D:/Project/1101/DBUtility/DbHelperSQL.cs</li>
</ul>
</div>
<!--- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>全部</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>类</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>名字空间</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>函数</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>变量</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(5)"><span class="SelectionMark">&#160;</span>枚举</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(6)"><span class="SelectionMark">&#160;</span>属性</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>

<hr class="footer"/><address class="footer"><small>Generated at Sun Apr 10 2011 19:47:50 for 1101 by&#160;
<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.7.2 </small></address>
</body>
</html>
